Skip to main content
Version: 4.2

Data Source Description

This chapter lists important parameters of all types of data sources that the supOS platform supports.

info

HANA data source is only for report elements presently.

Relational data source
Data SourceParameterDescription
SQL ServerData Source VersionThe database version of the SQL server.
OracleAccess ModeAccess the database by Server name or SID. Make sure to select the same mode as that of Oracle.
API data source
Data SourceParameterDescription
Web ServiceAddressInterface address of web service. Click Parse after entering the address, and then supOS automatically starts parsing the address.
HTTP AuthorizationEnable HTTP authorization and enter username and password to get authorization.
MethodSelect corresponding methods based on the address parsing results.
Resolve PathData path in response data XML file. For example: Body/OutputParameters/P_OUT_CONTENT/HEADERS/HEADER.
Input ModeDisplays corresponding input parameters based on the selected mode.
  • List mode: Click New and enter the parameter information under Input Parameter.
  • Xml mode: Configure data interface by entering xml text.
Output ModeDisplays corresponding output parameters based on the selected mode. Parse means to parse strings to display parameter list, and No parse means to return JSON strings.
RESTfulHTTP MethodRequest method of HTTP, which can be GET or POST.
Response Character EncodingSelect character encoding method.
Maximum allowable amount of data at one timeSet the maximum data volume returned at one time.
Headers ParameterHeader parameter of HTTP request.
Body parametersBody parameter of HTTP request.
  • FormData: Form submit method. You can select parameter type from Object and List, and click New to add parameters.
  • JSON: JSON submit method. You need to enter input parameters in JSON format.
info

When setting GET or DELETE as HTTP Method, only Form-data parameter is available.

Output parameter configurationThe output parameters of the API.
Output TypeThe output type of the API.
Response ResultResponse result of the API.
Object model data source
ParameterDescription
Local Data SourceEnable it to make the current supOS platform to be the data source.
supOS AddressEnter another supOS address and port.
supOS TenantEnter tenant name when the supOS is multi-tenant version.
supOS AuthenticationWhen connecting to another supOS platform, the supOS authentication is necessary. You can use the generated AK/SK credential to access the openAPI of supOS. For details, see Managing AK/SK Certificate.
File data source
Data SourceParameterDescription
Local and server file directoriesTypeOnly Server file is available.
Database File PathEnter the absolute path under /volumes/supfiles/. If the path does not exist, the platform will create it automatically.
HDFSFile Directory Relative PathDirectory relative path on hadoop server, and it stores HDFS files generated during Hive data transferring.
Server address/portThe IP address and port of hadoop server.
info
  • EXCEL and CSV files are supported.
  • HDFS must be working with Hive.
Big data storage
Data SourceParameterDescription
HiveData TransferEnable it and select an HDFS data source to save data to Hive through HDFS.
HBaseZookeeper IP/HostEnter the Zookeeper IP address. When it is under cluster deployment, use English comma to separate addresses.
Zookeeper PortZookeeper port. It is 2181 by default.
Master IP/HostMaster IP or hostname of cluster Zookeeper. Leave it empty when it is not under cluster deployment.
Special AuthenticationLeave it as default.
info

To connect with HBase data source, you need to cnfigure parameters at the X-ETL backend. For details, see Using X-ETL.